﻿/*
#------------------------------------------------------------------------------
#-- Program Name:	[dbo].[vwServerDisabledList]
#-- Purpose:		Filters tblServer to disabled servers only
#--	Last Update:	01/23/2012
#--					For a complete history - please review comments in Version
#--					Control.
#------------------------------------------------------------------------------
*/
CREATE VIEW [dbo].[vwServerDisabledList]
AS

SELECT		ROW_NUMBER() OVER(PARTITION BY srv_type_ro, srv_version_major_ro ORDER BY srv_type_ro, srv_version_major_ro, srv_server_name) rownum,
			srv_type_ro,
			srv_edition_ro,
			srv_server_name,
			srv_description,
			srv_product_version,
			srv_has_local_jobs,
			srv_has_master_jobs,
			srv_is_mixed_mode,
			srv_backup_directory,
			srv_version_major_ro,
			srv_version_minor_ro
FROM		dbo.tblServer
WHERE		srv_is_disabled = 1